Release 10.1A: OpenEdge Data Management:
SQL Reference

SQL-92 DDL and DML statements

Table 51 lists OpenEdge SQL DDL and DML Statements. A check mark identifies the compliance of each statement as SQL-92, a level of ODBC SQL Grammar, or as a Progress extension.

Table 51: Compliance of SQL-92 DDL and DML statements

OpenEdge SQL statement	SQL-92	ODBC SQL grammar	Progress extension	Notes
ALTER USER	–	–		–
CALL	–	Extended	–	Must enclose in an ODBC escape clause { fn }.
COMMIT		–	–	–
CONNECT		–	USING password	–
CREATE INDEX	–	Core	AREA area_name	–
CREATE PROCEDURE	–	Core		–
CREATE SYNONYM	–	–		–
CREATE TABLE		Minimum	AREA AS query_expression	–
CREATE TRIGGER	–	Core		–
CREATE USER	–	–		–
CREATE VIEW		Core	–	–
DELETE		Extended	–	–
DISCONNECT		–	–	–
DROP INDEX	–	Core	–	–
DROP PROCEDURE	–	Core		–
DROP SYNONYM	–	–		–
DROP TABLE	–	Minimum		–
DROP TRIGGER	–	–		–
DROP USER	–	–		–
DROP VIEW	–	Core		–
GRANT		Core	INDEX RESOURCE DBA	–
INSERT		Core	–	–
LOCK TABLE	–	–		–
REVOKE		Core	INDEX RESOURCE DBA	–
ROLLBACK		–	–	–
SELECT		Extended	FOR UPDATE	–
SET CONNECTION		–	–	–
SET SCHEMA		–	–	–
SET TRANSACTION ISOLATION LEVEL	–	–		–
UPDATE		Extended	assignments of form: ( column, column ) = ( expr, expr )	–
UPDATE STATISTICS	–	–		–